How to: Use predefined time formats.
Solution:
Select the cells containing the time to format. Select 'Cells...' from the 'Format' menu to display the 'Format Cells' dialog box. Click the 'Number' tab, select the 'Time' category, and select the desired format from the 'Type' list box.
1) Select the cells containing the time to format.
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Number' tab.
4) Select 'Time' from the 'Category' list box. (Excel displays the Type list box to the right of the Category list box.)
5) Select the desired predefined format from the 'Type' list box.
Selecting a predefined time format
6) Click 'OK'.
